Account Area
Your Location
Geo filtering is not configured
Filters
MYSQL ERROR
Error:User 'empadmin' has exceeded the 'max_questions' resource (current value: 300000)
Query:SELECT COUNT(`T1`.`website`) AS `Number`, SUM(IF(`T1`.`Category_ID` = '412' OR (FIND_IN_SET('412', `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0) OR (FIND_IN_SET('412', `T3`.`Parent_IDs`) > 0) , 1, 0)) AS `Category_count_412`, `T1`.`website` FROM `fl_listings` AS `T1` LEFT JOIN `fl_listing_plans` AS `T2` ON `T1`.`Plan_ID` = `T2`.`ID` LEFT JOIN `fl_categories` AS `T3` ON `T1`.`Category_ID` = `T3`.`ID` LEFT JOIN `fl_accounts` AS `T7` ON `T1`.`Account_ID` = `T7`.`ID` LEFT JOIN `fl_currency_rate` AS `CURCONV` ON SUBSTRING_INDEX(`T1`.`website`, '|', -1) = `CURCONV`.`Key` AND `CURCONV`.`Status` = 'active' WHERE (UNIX_TIMESTAMP(DATE_ADD(`T1`.`Pay_date`, INTERVAL `T2`.`Listing_period` DAY)) > UNIX_TIMESTAMP(NOW()) OR `T2`.`Listing_period` = 0) AND `T1`.`website` <> '' AND `T1`.`website` NOT LIKE '%+%' AND `T1`.`Status` = 'active' AND `T3`.`Status` = 'active' AND `T7`.`Status` = 'active' AND `T1`.`website` <> '0' AND (((`T1`.`Category_ID` = '412' OR (FIND_IN_SET('412', `T1`.`Crossed`) > 0 AND `T2`.`Cross` > 0)) OR FIND_IN_SET('412', `T3`.`Parent_IDs`) > 0)) AND `T1`.`website` = 'www.montefriopr.com' AND `T1`.`title` = 'Área Recreativa Monte Frío' AND `T1`.`towns` = 'Pueblo_Bayamon' AND `T1`.`phone` = '(787) 740-4005' AND `T1`.`b_address` = 'Carr. 831 km 6.5 Sector Pablo Silva Bo. Minillas' AND `T1`.`b_zip` = '00956' GROUP BY `T1`.`website` HAVING COUNT(`T1`.`website`) > 0 ORDER BY `Number` DESC
Function:include
File:/hermes/bosnacweb04/bosnacweb04bc/b2318/glo.mdprmaster/emp/libs/smarty/Smarty.class.php (line# 1258)